SELECT Id FROM new_searchtable
where
(town = 'Cornish' and state='NH'
or town = 'Eastman' and state='NH'
or town = 'Enfield' and state='NH'
or town = 'Hanover' and state='NH'
or town = 'Lebanon' and state='NH'
or town = 'Lyme' and state='NH'
or town = 'Plainfield' and state='NH'
)
and (type = 'R' or type ='O')
and (bedrooms='3') and (bedrooms='3')
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Upper Valley Area NH Homes page 15
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Located just outside the heart of Hanover, the home is perfect for those looking for privacy. The home features a functional layout designed to take advantage of its natural surroundings. Hardwood floors run throughout the main level, where a spacious living room with a pellet stove offers a cozy retreat during colder months. The main level is bright and sunny with a wrap-around deck off the main living space which provides an ideal spot for enjoying the warmer months. The lower level provides great overflow space and includes a gas fireplace, a laundry area, and a three quarter bath. A converted garage spaces now serves as a practical mudroom, storage area, or potential workshop. Outside, the property’s expansive front and back yards, offer ample space for outdoor activities, gardening, privacy, and relaxation. With its desirable location near hiking trails, schools, and cultural attractions, this home offers a quiet retreat without sacrificing proximity to Hanover’s vibrant downtown.
Description:This beautifully renovated Hanover home offers a rare opportunity with a great price and modern updates. Nearly fully updated on both levels, the home is filled with natural light and features a comfortable, efficient floor plan. Located just 10 minutes from downtown Hanover, it's tucked away from the road and surrounded by trees. The flat yard is perfect for outdoor activities. A heated, direct-entry two-car garage leads to the lower level, which includes a newly renovated family room and a flexible space that can serve as a rec room, exercise room, or guest bedroom. A stylish 3/4 bath adds extra convenience, along with a small laundry room with a stackable washer and dryer. The second level is where the home truly shines. The main living area features a modern kitchen with a large sit-up island, Quartz countertops, and a seamless flow into the dining and living areas. A cozy pellet stove adds warmth, while a mini-split unit ensures comfort in summer. The inviting color palette and layout are perfect for entertaining. Just off the kitchen, the deck is ideal for summer BBQs. This level also includes three bedrooms, each with its own mini-split for personalized climate control, and a fully renovated full bath. Sellers installed a brand new septic in 2019. Come see what this property has to offer. Showings begin at the open house on Saturday, April 5th and Sunday, April 6th 9am to 12pm.
Description:Escape to your own slice of paradise with this stunning 3-bedroom, 2.5-bath home offering breathtaking, expansive views! Nestled on 21 acres of picturesque land, this property is perfect for nature lovers, hobby farmers, or anyone seeking tranquility while still being close to Dartmouth, schools, shopping, restaurants. Enjoy the perfect blend of modern comfort and outdoor living with an attached garage, a spacious barn, and miles of trails right outside your door.The master suite is a spacious retreat with a private bath and walk in closet while the two additional bedrooms offer ample space for family, guests, or a home office with hi speed internet. The open living and dining areas feature large windows that bring the scenic surroundings indoors, creating a bright and welcoming atmosphere.Enjoy the fireplace warmth as you watch the wildlife through the many windows.Additional features include an attached 2-car garage for secure parking and storage, as well as a barn that's perfect for animals, equipment, or hobbies. The expansive 21 acres includes fields and trails, providing endless opportunities for outdoor recreation, whether it’s hiking, horseback riding, cross country skiing, snowmobiling,or just enjoying the peaceful surroundings.**The 126 acre abutting lot is also available for sale. See MLS#5027346. Some photos are virtually staged.
Description:This light-filled, contemporary home with 3 bedrooms and 2.5 baths is situated in a highly desirable cul-de-sac located mere minutes from downtown Hanover and Dartmouth College. The kitchen opens into a bright dining area with cathedral ceiling. A sunbathed living room with fireplace, a cozy family room and a home office complete the first floor. The primary bedroom with ensuite bathroom, as well as two nicely sized bedrooms and a full bath comprise the second floor. Enjoy the options of a finished basement with natural light. The outdoor space is highlighted by a great back deck overlooking a cleared backyard. Further outdoor enjoyment awaits at Storrs Pond Recreation Area and trail network- just a mile away. A terrific home in premier neighborhood and location! The office photo is virtually staged. SHOWINGS BEGIN FRIDAY, 3/28/25.
Description:Sited on a southeast-facing ridge in the hills of Plainfield, this extraordinary estate seamlessly blends elegance, solitude, and natural beauty. The private 103 acres of pristine woodlands with multiple ponds, meandering hiking and riding trails, and views of local hills and distant mountains, offers the ultimate retreat while being just minutes from Dartmouth College, DHMC, I-89, and I-91. Its location provides both tranquility and convenient access to the best of the Upper Valley, Boston, and beyond. The residence is a unique fusion of Tuscan-inspired design, Italian elegance, and traditional New England craftsmanship. Recently renovated with meticulous attention to detail, the home features a sun-drenched, flexible floor plan with five spacious bedrooms, multiple additional spaces to use as you see fit, and a guest wing. The redesigned eat-in kitchen and breakfast nook showcase modern updates, while radiant heat, wood, and pellet stoves ensure cozy warmth. Notable features such as the observation tower provide unique spaces to relax, take in the spectacular views, and stargaze. The property is designed for both leisure and function and includes a 2-bay attached garage, 1-bay under, 3-bay detached barn, and more. There's ample space for your hobbies and all the gear. Whether exploring the trails, enjoying the ponds, or hosting in the expansive living spaces, this retreat delivers a lifestyle of unmatched serenity, privacy, luxury, and sophistication.